import pymysql
from pyecharts.charts import Bar
from pyecharts import options
db = pymysql.connect(
    host="localhost",
    user="root",
    password="komirou",
    database="crawlerdemo",
    charset="utf8"
)
cursor = db.cursor()
sql = "select min(job_sal), job_place from job group by job_place order by min(job_sal) limit 5"
sal = []
city = []
try:
    cursor.execute(sql)
    res = cursor.fetchall()
    for i in res:
        sal.append(i[0])
        city.append(i[1])
except:
    print("查询出问题了")
cursor.close()
db.close()
bar = Bar()
bar.add_xaxis(city)
bar.add_yaxis("月薪水/元", sal)
bar.set_global_opts(title_opts=options.TitleOpts(title="最低工资的五个城市", subtitle="单位/元"))
bar.render("barmin.html")
